A Dependability Benchmark for OLTP Application Environments
نویسندگان
چکیده
The ascendance of networked information in our economy and daily lives has increased the awareness of the importance of dependability features. OLTP (On-Line Transaction Processing) systems constitute the kernel of the information systems used today to support the daily operations of most of the business. Although these systems comprise the best examples of complex business-critical systems, no practical way has been proposed so far to characterize the impact of faults in such systems or to compare alternative solutions concerning dependability features. This paper proposes a dependability benchmark for OLTP systems. This dependability benchmark uses the workload of the TPC-C performance benchmark and specifies the measures and all the steps required to evaluate both the performance and key dependability features of OLTP systems, with emphasis on availability. This dependability benchmark is presented through a concrete example of benchmarking the performance and dependability of several different transactional systems configurations. The effort required to run the dependability benchmark is also discussed in detail.
منابع مشابه
Benchmarking the Dependability of Different OLTP Systems
On-Line Transaction Processing (OLTP) systems constitute the kernel of the information systems used today to support the daily operations of most organizations. Although these systems comprise the best examples of complex business-critical systems, no practical way has been proposed so far to characterize the impact of faults in such systems or to compare alternative solutions concerning depend...
متن کاملA Data Mining Approach to Identify Key Factors in Dependability Experiments
Our paper presents a novel approach for identifying the key infrastructural factors determining the behavior of systems in the presence of faults by the application of intelligent data processing methods on data sets obtained from dependability benchmarking experiments. Our approach does not rely on a-priori assumptions or human intuition about the dominant aspects enabling this way the investi...
متن کاملAn Automatic Source Code Generation Tool for OLTP Database Benchmarks
H-Store [3] is a research OLTP DBMS project being developed in collaboration by MIT, Brown University, Yale University and HP Labs. Based on assumptions that long-running transactions are not needed for highend OLTP applications and OLTP DBMS can do without disks [11] , H-Store has some features that do not exist in current market-leading DMBS products. For example, H-Store is designed without ...
متن کاملDemonstrating Near Real-Time Analytics with IBM DB2 Analytics Accelerator
Version 3 of the IBM DB2 Analytics Accelerator (IDAA) takes a major step towards the vision of a universal relational DBMS that transparently processes both, OLTP and analytical-type queries in a single system. Based on heuristics in DB2 for z/OS, the DB2 optimizer decides if a query should be executed by ”mainline” DB2 or if it is beneficial to forward it to the attached IBM DB2 Analytics Opti...
متن کاملOltp Performance Improvement Using File - Systems Layer Compression
Database for Online Transaction Processing (OLTP) application is used by almost every corporations that has adopted computerisation to support their operational day to day business. Compression in the storage or file-systems layer has not been widely adopted for OLTP database because of the concern that it might decrease database performance. OLTP compression in the database layer is available ...
متن کامل